CREATE TABLE [dbo].[JOL_Recruitment_Position]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[participants_apply] [int] NULL,
[position] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[target] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[work_area] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[work_city] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL,
[quantity] [int] NULL,
[professional] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[degree] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[description] [nvarchar] (max) COLLATE Chinese_PRC_CI_AS NULL,
[visit_times] [int] NULL,
[remark] [nvarchar] (max) COLLATE Chinese_PRC_CI_AS NULL,
[add_time] [smalldatetime] NULL,
[user_add] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[update_time] [smalldatetime] NULL,
[user_update] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL,
[current_stage] [int] NULL,
[state] [bit] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_Recruitment_Position] ADD CONSTRAINT [PK_JOL_Recruitment_ Position] PRIMARY KEY CLUSTERED  ([id]) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'当前处理阶段', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Position', 'COLUMN', N'current_stage'
GO
EXEC sp_addextendedproperty N'MS_Description', N'学历要求', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Position', 'COLUMN', N'degree'
GO
EXEC sp_addextendedproperty N'MS_Description', N'详细描述', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Position', 'COLUMN', N'description'
GO
EXEC sp_addextendedproperty N'MS_Description', N'参会申请', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Position', 'COLUMN', N'participants_apply'
GO
EXEC sp_addextendedproperty N'MS_Description', N'招聘岗位', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Position', 'COLUMN', N'position'
GO
EXEC sp_addextendedproperty N'MS_Description', N'专业要求', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Position', 'COLUMN', N'professional'
GO
EXEC sp_addextendedproperty N'MS_Description', N'招聘人数', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Position', 'COLUMN', N'quantity'
GO
EXEC sp_addextendedproperty N'MS_Description', N'备注', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Position', 'COLUMN', N'remark'
GO
EXEC sp_addextendedproperty N'MS_Description', N'完成状态', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Position', 'COLUMN', N'state'
GO
EXEC sp_addextendedproperty N'MS_Description', N'招聘对象', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Position', 'COLUMN', N'target'
GO
EXEC sp_addextendedproperty N'MS_Description', N'浏览次数', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Position', 'COLUMN', N'visit_times'
GO
EXEC sp_addextendedproperty N'MS_Description', N'工作地区', 'SCHEMA', N'dbo', 'TABLE', N'JOL_Recruitment_Position', 'COLUMN', N'work_area'
GO
